Tabela ResponsibilityCenter

Definicja tabeli ResponsibilityCenter

Name

ResponsibilityCenter

Code

ResponsibilityCenter

Comment

Osrodki odpowiedzialnosci


Lista kolumn tabeli ResponsibilityCenter

Name

Code

ResponsibilityCenterID

ResponsibilityCenterID

RespCenterStructureID

RespCenterStructureID

ParentCenterID

ParentCenterID

Name

Name

Description

Description

CostCenter

CostCenter

Editable

Editable

ElementIndex

ElementIndex

GroupingElement

GroupingElement


Kolumna ResponsibilityCenterID tabeli ResponsibilityCenter

Definicja kolumny ResponsibilityCenterID tabeli ResponsibilityCenter

Name

ResponsibilityCenterID

Code

ResponsibilityCenterID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID osrodka


Kolumna RespCenterStructureID tabeli ResponsibilityCenter

Definicja kolumny RespCenterStructureID tabeli ResponsibilityCenter

Name

RespCenterStructureID

Code

RespCenterStructureID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID struktury osrodków odpowiedzialnosci


Kolumna ParentCenterID tabeli ResponsibilityCenter

Definicja kolumny ParentCenterID tabeli ResponsibilityCenter

Name

ParentCenterID

Code

ParentCenterID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID osrodka nadrzednego


Kolumna Name tabeli ResponsibilityCenter

Definicja kolumny Name tabeli ResponsibilityCenter

Name

Name

Code

Name

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

Nazwa


Kolumna Description tabeli ResponsibilityCenter

Definicja kolumny Description tabeli ResponsibilityCenter

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Opis


Kolumna CostCenter tabeli ResponsibilityCenter

Definicja kolumny CostCenter tabeli ResponsibilityCenter

Name

CostCenter

Code

CostCenter

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Kod osrodka lub osrodków kosztów


Kolumna Editable tabeli ResponsibilityCenter

Definicja kolumny Editable tabeli ResponsibilityCenter

Name

Editable

Code

Editable

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Flaga mówiaca czy wartosc cyklu budzetowego przypisana do osrodka odpowiedzialnosci moze byc edytowalna przez uzytkownika


Kolumna ElementIndex tabeli ResponsibilityCenter

Definicja kolumny ElementIndex tabeli ResponsibilityCenter

Name

ElementIndex

Code

ElementIndex

Data Type

NUMBER(5)

Mandatory

No

Comment

Indeks elementu porzadkujacy strukture


Kolumna GroupingElement tabeli ResponsibilityCenter

Definicja kolumny GroupingElement tabeli ResponsibilityCenter

Name

GroupingElement

Code

GroupingElement

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Czy jest to element grupujacy w drzewie


Lista kluczy tabeli ResponsibilityCenter

Name

Code

Primary

PK_RESPONSIBILITYCENTER

PK_RESPONSIBILITYCENTER

X


Klucz PK_RESPONSIBILITYCENTER tabeli ResponsibilityCenter

Definicja klucza PK_RESPONSIBILITYCENTER tabeli ResponsibilityCenter

Name

PK_RESPONSIBILITYCENTER

Code

PK_RESPONSIBILITYCENTER

Primary

Yes

Comment